<html>
<head>
        <title>HHP4 特殊台词收集表</title>
        <meta http-equiv='Content-Type' content="text/html; charset=utf-8">
<style>
table{
  background:#e1ebf5;
  border:2px;
  font-size:12px;
}

</style>
</head>
<body bgcolor=#e1ebf5>
<?php
require_once('helper/dbmysql_class.php');
require_once('config.php');
$rs=$db->execute("select distinct st.type,sk.stype,sk.sgid from spectalk st,skill sk where st.type=sk.sgid order by type asc;");
$iniinfo = parse_ini_file('talkconf.ini');
while($r=$db->fetch_array($rs)) {
	switch($r['sgid']) {
		case 0:{$stotal = $iniinfo['physkill_small.php'] + $iniinfo['physkill_medium.php'] + $iniinfo['physkill_large.php'];break;}
		case 10:{$stotal = $iniinfo['physkill_verylarge.php'] + $iniinfo['physkill_superlarge.php'] + $iniinfo['physkill_superverylarge.php'];break;}
		case 1:{$stotal = $iniinfo['mgcskill_fire.php'];break;}
		case 2:{$stotal = $iniinfo['mgcskill_ice.php'];break;}
		case 3:{$stotal = $iniinfo['mgcskill_thunder.php'];break;}
		case 4:{$stotal = $iniinfo['mgcskill_earth.php'];break;}
		case 5:{$stotal = $iniinfo['mgcskill_wind.php'];break;}
		case 6:{$stotal = $iniinfo['mgcskill_light.php'];break;}
		case 7:{$stotal = $iniinfo['mgcskill_dark.php'];break;}
		case 8:{$stotal = $iniinfo['mgcskill_omni.php'];break;}
		case 9:{$stotal = $iniinfo['specskill_class.php'];break;}
		case 11:{$stotal = $iniinfo['abnskill_class.php'];break;}
		case 12:{$stotal = $iniinfo['cureskill_class.php'];break;}
		case 13:{$stotal = $iniinfo['sptskill_class.php'];break;}
	}
	echo $r['stype']."分类收集率统计：".$stotal;
	echo "<table border=1>";
	echo "<tr>";
	echo "\t<td>分类</td>\n";
	echo "\t<td>技能</td>\n";
	echo "\t<td>台词</td>\n";
	echo "\t<td>解封时间</td>\n";
	echo "</tr>";
	$rs2=$db->execute("select st.*,sk.stype,sk.sname from spectalk st,skill sk where st.sid=sk.suid and st.type=".$r['type']);
	while($r2=$db->fetch_array($rs2)) {
		echo "<tr>";
		echo "\t<td>".$r2['stype']."</td>";
		echo "\t<td>".$r2['sname']."</td>";
		echo "\t<td>".$r2['content']."</td>";
		echo "\t<td>".$r2['timeline']."</td>";
		echo "</tr>";
	}
}

?>
</body>
</html>
